#!/usr/bin/env python
# _*_ coding:utf-8 _*_
#Author: Tian Yin Fan
import xlsxwriter
import sys
reload(sys)
sys.setdefaultencoding('utf8')

workbook = xlsxwriter.Workbook("student.xlsx")
worksheet = workbook.add_worksheet("student")

dict1 = {
    "1":["张三",150,120,100],
    "2":["李四",90,99,95],
    "3":["王五",60,66,68]
}

for (k, v) in dict1.items():
    #print k,v
    worksheet.write(A, k)
    A="A"+str(k)
    B="B"+str(k)
    C="C"+str(k)
    D="D"+str(k)
    E="E"+str(k)

    list1=[B,C,D,E]
    list2=v
    newDict=dict(zip(list1,list2))

    for (k1,v1) in newDict.items():

        worksheet.write(k1,v1)
        print("THe key: " + k1) + " the value: " + str(v1))

workbook.close()




